﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace ResourceLoadBalancer.Client
{
    public class SQLServerScanner
    {
        //private IList<string> getTables()
        //{
        //    string connectString = @"Data Source=YOURPC\SQLEXPRESS;Initial Catalog=databasename;Integrated Security=True";
        //    SqlConnection con = new SqlConnection(connectString);
        //    con.Open();
        //    string thesql = "select * from product where type_id=";
        //    SqlCommand cmd = new SqlCommand(thesql, con);
        //    SqlDataReader reader = cmd.ExecuteReader();
        //    while (reader.Read())
        //    {
        //        string order = reader[0].ToString();
                
        //    }
        //    reader.Close();
        //    con.Close();
        //}
    }
}
